/*
通用的数据库方法
 */
const {query}= require('../util/query')

let getRoleByUserId = async function(id) {
    let _sql = `
    SELECT ROLE_ID FROM AUTH_USER_ROLE WHERE USER_ID='${id}' limit 1;
  `
    let result = await query(_sql)

    return result[0].ROLE_ID
}
module.exports = {
    getRoleByUserId
}
